Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	119711
Missing cells	1926
Missing cells (%)	0.1%
Duplicate rows	199
Duplicate rows (%)	0.2%
Total size in memory	15.5 MiB
Average record size in memory	136.0 B

Variable types

Categorical	3
Text	1
Numeric	11
DateTime	1

Alerts

Dataset has 199 (0.2%) duplicate rows	Duplicates
`so2` is highly overall correlated with `SOi`	High correlation
`no2` is highly overall correlated with `Noi`	High correlation
`rspm` is highly overall correlated with `spm` and 2 other fields	High correlation
`spm` is highly overall correlated with `rspm` and 5 other fields	High correlation
`pm2_5` is highly overall correlated with `spm` and 3 other fields	High correlation
`SOi` is highly overall correlated with `so2`	High correlation
`Noi` is highly overall correlated with `no2`	High correlation
`SPMi` is highly overall correlated with `rspm` and 5 other fields	High correlation
`PMi` is highly overall correlated with `spm` and 3 other fields	High correlation
`AQI` is highly overall correlated with `rspm` and 5 other fields	High correlation
`AQI_Range` is highly overall correlated with `spm` and 2 other fields	High correlation
`type` has 1925 (1.6%) missing values	Missing
`RSPMi` has 19323 (16.1%) zeros	Zeros

Reproduction

Analysis started	2023-11-18 06:46:54.074117
Analysis finished	2023-11-18 06:47:23.858344
Duration	29.78 seconds
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

state
Categorical

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

West Bengal	22463
Gujarat	21279
Tamil Nadu	20597
Madhya Pradesh	19920
Odisha	19279
Other values (4)	16173

Length

Max length	20
Median length	11
Mean length	9.0152534
Min length	3

Characters and Unicode

Total characters	1079225
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Dadra & Nagar Haveli
2nd row	Dadra & Nagar Haveli
3rd row	Dadra & Nagar Haveli
4th row	Dadra & Nagar Haveli
5th row	Dadra & Nagar Haveli

Common Values

Value	Count	Frequency (%)
West Bengal	22463	18.8%
Gujarat	21279	17.8%
Tamil Nadu	20597	17.2%
Madhya Pradesh	19920	16.6%
Odisha	19279	16.1%
Delhi	8551	7.1%
Goa	6206	5.2%
Daman & Diu	782	0.7%
Dadra & Nagar Haveli	634	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
west	22463	12.1%
bengal	22463	12.1%
gujarat	21279	11.4%
tamil	20597	11.1%
nadu	20597	11.1%
madhya	19920	10.7%
pradesh	19920	10.7%
odisha	19279	10.4%
delhi	8551	4.6%
goa	6206	3.3%
Other values (6)	4882	2.6%

Most occurring characters

Value	Count	Frequency (%)
a	196194	18.2%
d	80350	7.4%
e	74031	6.9%
h	67670	6.3%
	66446	6.2%
s	61662	5.7%
l	52245	4.8%
i	49843	4.6%
t	43742	4.1%
u	42658	4.0%
Other values (19)	344384	31.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	826622	76.6%
Uppercase Letter	184741	17.1%
Space Separator	66446	6.2%
Other Punctuation	1416	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	196194	23.7%
d	80350	9.7%
e	74031	9.0%
h	67670	8.2%
s	61662	7.5%
l	52245	6.3%
i	49843	6.0%
t	43742	5.3%
u	42658	5.2%
r	42467	5.1%
Other values (7)	115760	14.0%

Uppercase Letter

Value	Count	Frequency (%)
G	27485	14.9%
B	22463	12.2%
W	22463	12.2%
N	21231	11.5%
T	20597	11.1%
M	19920	10.8%
P	19920	10.8%
O	19279	10.4%
D	10749	5.8%
H	634	0.3%

Space Separator

Value	Count	Frequency (%)
	66446	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	1416	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1011363	93.7%
Common	67862	6.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	196194	19.4%
d	80350	7.9%
e	74031	7.3%
h	67670	6.7%
s	61662	6.1%
l	52245	5.2%
i	49843	4.9%
t	43742	4.3%
u	42658	4.2%
r	42467	4.2%
Other values (17)	300501	29.7%

Common

Value	Count	Frequency (%)
	66446	97.9%
&	1416	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1079225	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	196194	18.2%
d	80350	7.4%
e	74031	6.9%
h	67670	6.3%
	66446	6.2%
s	61662	5.7%
l	52245	4.8%
i	49843	4.6%
t	43742	4.1%
u	42658	4.0%
Other values (19)	344384	31.9%

location
Text

Distinct	101
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Length

Max length	17
Median length	13
Mean length	7.1725572
Min length	4

Characters and Unicode

Total characters	858634
Distinct characters	47
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Daman
2nd row	Daman
3rd row	Daman
4th row	Daman
5th row	Daman

Value	Count	Frequency (%)
delhi	8551	6.9%
kolkata	7733	6.3%
chennai	6646	5.4%
ahmedabad	6256	5.1%
howrah	3601	2.9%
indore	3456	2.8%
bhopal	3449	2.8%
surat	3441	2.8%
coimbatore	3268	2.7%
nagda	3038	2.5%
Other values (91)	73699	59.9%

Most occurring characters

Value	Count	Frequency (%)
a	154914	18.0%
r	55921	6.5%
o	51147	6.0%
h	47595	5.5%
e	47539	5.5%
l	44369	5.2%
i	41925	4.9%
n	40146	4.7%
d	40103	4.7%
u	38090	4.4%
Other values (37)	296885	34.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	722956	84.2%
Uppercase Letter	129335	15.1%
Space Separator	3427	0.4%
Open Punctuation	1375	0.2%
Close Punctuation	1375	0.2%
Other Punctuation	166	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	154914	21.4%
r	55921	7.7%
o	51147	7.1%
h	47595	6.6%
e	47539	6.6%
l	44369	6.1%
i	41925	5.8%
n	40146	5.6%
d	40103	5.5%
u	38090	5.3%
Other values (12)	161207	22.3%

Uppercase Letter

Value	Count	Frequency (%)
A	14171	11.0%
D	13971	10.8%
C	13839	10.7%
B	13270	10.3%
S	12060	9.3%
K	9418	7.3%
R	8552	6.6%
H	6657	5.1%
V	6554	5.1%
T	6358	4.9%
Other values (11)	24485	18.9%

Space Separator

Value	Count	Frequency (%)
	3427	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1375	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1375	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	166	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	852291	99.3%
Common	6343	0.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	154914	18.2%
r	55921	6.6%
o	51147	6.0%
h	47595	5.6%
e	47539	5.6%
l	44369	5.2%
i	41925	4.9%
n	40146	4.7%
d	40103	4.7%
u	38090	4.5%
Other values (33)	290542	34.1%

Common

Value	Count	Frequency (%)
	3427	54.0%
(	1375	21.7%
)	1375	21.7%
&	166	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	858634	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	154914	18.0%
r	55921	6.5%
o	51147	6.0%
h	47595	5.5%
e	47539	5.5%
l	44369	5.2%
i	41925	4.9%
n	40146	4.7%
d	40103	4.7%
u	38090	4.4%
Other values (37)	296885	34.6%

type
Categorical

MISSING

Distinct	9
Distinct (%)	< 0.1%
Missing	1925
Missing (%)	1.6%
Memory size	1.8 MiB

Residential, Rural and other Areas	44872
Industrial Area	28814
Residential and others	25633
Industrial Areas	16264
RIRUO	1304
Other values (4)	899

Length

Max length	34
Median length	22
Mean length	23.777732
Min length	5

Characters and Unicode

Total characters	2800684
Distinct characters	21
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Industrial Areas
2nd row	Industrial Areas
3rd row	Industrial Areas
4th row	Industrial Areas
5th row	Industrial Areas

Common Values

Value	Count	Frequency (%)
Residential, Rural and other Areas	44872	37.5%
Industrial Area	28814	24.1%
Residential and others	25633	21.4%
Industrial Areas	16264	13.6%
RIRUO	1304	1.1%
Sensitive Area	371	0.3%
Sensitive Areas	323	0.3%
Industrial	138	0.1%
Residential	67	0.1%
(Missing)	1925	1.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
residential	70572	17.9%
and	70505	17.9%
areas	61459	15.6%
industrial	45216	11.5%
rural	44872	11.4%
other	44872	11.4%
area	29185	7.4%
others	25633	6.5%
riruo	1304	0.3%
sensitive	694	0.2%

Most occurring characters

Value	Count	Frequency (%)
a	321809	11.5%
e	303681	10.8%
	276526	9.9%
r	251237	9.0%
s	203574	7.3%
i	187748	6.7%
n	186987	6.7%
t	186987	6.7%
d	186293	6.7%
l	160660	5.7%
Other values (11)	535182	19.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2220768	79.3%
Space Separator	276526	9.9%
Uppercase Letter	258518	9.2%
Other Punctuation	44872	1.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	321809	14.5%
e	303681	13.7%
r	251237	11.3%
s	203574	9.2%
i	187748	8.5%
n	186987	8.4%
t	186987	8.4%
d	186293	8.4%
l	160660	7.2%
u	90088	4.1%
Other values (3)	141704	6.4%

Uppercase Letter

Value	Count	Frequency (%)
R	118052	45.7%
A	90644	35.1%
I	46520	18.0%
U	1304	0.5%
O	1304	0.5%
S	694	0.3%

Space Separator

Value	Count	Frequency (%)
	276526	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	44872	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2479286	88.5%
Common	321398	11.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	321809	13.0%
e	303681	12.2%
r	251237	10.1%
s	203574	8.2%
i	187748	7.6%
n	186987	7.5%
t	186987	7.5%
d	186293	7.5%
l	160660	6.5%
R	118052	4.8%
Other values (9)	372258	15.0%

Common

Value	Count	Frequency (%)
	276526	86.0%
,	44872	14.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2800684	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	321809	11.5%
e	303681	10.8%
	276526	9.9%
r	251237	9.0%
s	203574	7.3%
i	187748	6.7%
n	186987	6.7%
t	186987	6.7%
d	186293	6.7%
l	160660	5.7%
Other values (11)	535182	19.1%

so2
Real number (ℝ)

HIGH CORRELATION

Distinct	2386
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.130261

Minimum	0
Maximum	909
Zeros	788
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	5.12
median	9
Q3	13.7
95-th percentile	24.6
Maximum	909
Range	909
Interquartile range (IQR)	8.58

Descriptive statistics

Standard deviation	12.964224
Coefficient of variation (CV)	1.1647727
Kurtosis	409.49293
Mean	11.130261
Median Absolute Deviation (MAD)	4
Skewness	13.332617
Sum	1332414.7
Variance	168.07111
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	9920	8.3%
4	5565	4.6%
5	3338	2.8%
11	3250	2.7%
5.275873979	3205	2.7%
10	3148	2.6%
9	3067	2.6%
7	3042	2.5%
8	3012	2.5%
13	2987	2.5%
Other values (2376)	79177	66.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	788	0.7%
0.2	3	< 0.1%
0.3	6	< 0.1%
0.4	2	< 0.1%
0.47	1	< 0.1%
0.5	29	< 0.1%
0.6	7	< 0.1%
0.7	2	< 0.1%
0.8	5	< 0.1%
0.9	11	< 0.1%

Value	Count	Frequency (%)
909	1	< 0.1%
498	1	< 0.1%
492	1	< 0.1%
482	1	< 0.1%
421	1	< 0.1%
407	1	< 0.1%
405	1	< 0.1%
393	1	< 0.1%
380	1	< 0.1%
372	1	< 0.1%

no2
Real number (ℝ)

HIGH CORRELATION

Distinct	3541
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.574397

Minimum	0
Maximum	592
Zeros	769
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	8.8
Q1	15.6
median	22
Q3	35
95-th percentile	76
Maximum	592
Range	592
Interquartile range (IQR)	19.4

Descriptive statistics

Standard deviation	24.207636
Coefficient of variation (CV)	0.81853354
Kurtosis	20.937494
Mean	29.574397
Median Absolute Deviation (MAD)	8
Skewness	3.1229677
Sum	3540380.7
Variance	586.00965
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	2989	2.5%
21	2704	2.3%
22	2400	2.0%
19	2329	1.9%
18	2125	1.8%
23	2106	1.8%
17	2104	1.8%
10	1962	1.6%
13	1959	1.6%
24	1909	1.6%
Other values (3531)	97124	81.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	769	0.6%
0.2	1	< 0.1%
0.3	1	< 0.1%
0.5	4	< 0.1%
0.6	2	< 0.1%
0.7	4	< 0.1%
0.75	1	< 0.1%
0.8	2	< 0.1%
0.9	7	< 0.1%
1	7	< 0.1%

Value	Count	Frequency (%)
592	1	< 0.1%
484.3	1	< 0.1%
475	1	< 0.1%
449.4	1	< 0.1%
444	1	< 0.1%
439.1	1	< 0.1%
423.5	1	< 0.1%
377	1	< 0.1%
366	1	< 0.1%
353.5	1	< 0.1%

rspm
Real number (ℝ)

HIGH CORRELATION

Distinct	2581
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	101.16855

Minimum	0
Maximum	1183.5
Zeros	762
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	29.333333
Q1	58
median	86
Q3	119
95-th percentile	231
Maximum	1183.5
Range	1183.5
Interquartile range (IQR)	61

Descriptive statistics

Standard deviation	68.542161
Coefficient of variation (CV)	0.67750461
Kurtosis	9.0698813
Mean	101.16855
Median Absolute Deviation (MAD)	30
Skewness	2.2897295
Sum	12110989
Variance	4698.0279
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
114.7179675	3046	2.5%
98.24450975	2207	1.8%
196.6397705	1884	1.6%
66.58563751	1805	1.5%
115.0399092	1168	1.0%
86	989	0.8%
75	980	0.8%
84	972	0.8%
82	948	0.8%
83.61982436	946	0.8%
Other values (2571)	104766	87.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	762	0.6%
3	19	< 0.1%
4	6	< 0.1%
5	9	< 0.1%
6	8	< 0.1%
6.33	1	< 0.1%
7	15	< 0.1%
7.67	2	< 0.1%
8	5	< 0.1%
8.33	3	< 0.1%

Value	Count	Frequency (%)
1183.5	1	< 0.1%
981	1	< 0.1%
892	1	< 0.1%
843	1	< 0.1%
834.5	1	< 0.1%
784	1	< 0.1%
776	1	< 0.1%
735	1	< 0.1%
728	1	< 0.1%
718	2	< 0.1%

spm
Real number (ℝ)

HIGH CORRELATION

Distinct	3971
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	195.49148

Minimum	0
Maximum	2366
Zeros	900
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	49
Q1	126.72906
median	179
Q3	233.50652
95-th percentile	400
Maximum	2366
Range	2366
Interquartile range (IQR)	106.77746

Descriptive statistics

Standard deviation	117.61571
Coefficient of variation (CV)	0.60164109
Kurtosis	9.0987696
Mean	195.49148
Median Absolute Deviation (MAD)	52.270936
Skewness	2.0108266
Sum	23402480
Variance	13833.455
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
126.7290644	11067	9.2%
233.5065239	9457	7.9%
167.6098436	8371	7.0%
210.0675451	7903	6.6%
191.5679298	7372	6.2%
399.4020883	3092	2.6%
67.25419257	2924	2.4%
0	900	0.8%
144	300	0.3%
175	282	0.2%
Other values (3961)	68043	56.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	900	0.8%
1	6	< 0.1%
1.61	2	< 0.1%
2	7	< 0.1%
2.99	1	< 0.1%
3	3	< 0.1%
4	7	< 0.1%
4.42	1	< 0.1%
5	2	< 0.1%
6	4	< 0.1%

Value	Count	Frequency (%)
2366	1	< 0.1%
1885	1	< 0.1%
1844	1	< 0.1%
1795	1	< 0.1%
1682	1	< 0.1%
1654	1	< 0.1%
1560	1	< 0.1%
1503	1	< 0.1%
1465	1	< 0.1%
1450	1	< 0.1%

pm2_5
Real number (ℝ)

HIGH CORRELATION

Distinct	442
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48.46177

Minimum	3
Maximum	504
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	3
5-th percentile	18.855612
Q1	30.511628
median	42.204089
Q3	64.890625
95-th percentile	95.113208
Maximum	504
Range	501
Interquartile range (IQR)	34.378997

Descriptive statistics

Standard deviation	21.743671
Coefficient of variation (CV)	0.44867678
Kurtosis	5.3684192
Mean	48.46177
Median Absolute Deviation (MAD)	13.204089
Skewness	1.089178
Sum	5801407
Variance	472.78723
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
64.890625	21823	18.2%
29.55044053	20143	16.8%
65.06456454	19091	15.9%
30.72969596	18878	15.8%
42.20408895	16491	13.8%
95.11320755	8180	6.8%
18.85561151	4816	4.0%
27.88636364	738	0.6%
30.51162791	591	0.5%
30	322	0.3%
Other values (432)	8638	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	1	< 0.1%
4	4	< 0.1%
5	8	< 0.1%
6	5	< 0.1%
7	9	< 0.1%
8	14	< 0.1%
9	52	< 0.1%
9.7	1	< 0.1%
9.9	1	< 0.1%
10	129	0.1%

Value	Count	Frequency (%)
504	1	< 0.1%
395	1	< 0.1%
331	2	< 0.1%
318	1	< 0.1%
304	1	< 0.1%
303	1	< 0.1%
300	1	< 0.1%
297	1	< 0.1%
294	1	< 0.1%
283	1	< 0.1%

date
Date

Distinct	4895
Distinct (%)	4.1%
Missing	1
Missing (%)	< 0.1%
Memory size	1.8 MiB

Minimum	1987-01-01 00:00:00
Maximum	2015-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

SOi
Real number (ℝ)

HIGH CORRELATION

Distinct	2386
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.661453

Minimum	0
Maximum	313.625
Zeros	788
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	2.5
Q1	6.4
median	11.25
Q3	17.125
95-th percentile	30.75
Maximum	313.625
Range	313.625
Interquartile range (IQR)	10.725

Descriptive statistics

Standard deviation	12.404329
Coefficient of variation (CV)	0.90798017
Kurtosis	39.530089
Mean	13.661453
Median Absolute Deviation (MAD)	5
Skewness	4.6605571
Sum	1635426.2
Variance	153.86737
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.5	9920	8.3%
5	5565	4.6%
6.25	3338	2.8%
13.75	3250	2.7%
6.594842473	3205	2.7%
12.5	3148	2.6%
11.25	3067	2.6%
8.75	3042	2.5%
10	3012	2.5%
16.25	2987	2.5%
Other values (2376)	79177	66.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	788	0.7%
0.25	3	< 0.1%
0.375	6	< 0.1%
0.5	2	< 0.1%
0.5875	1	< 0.1%
0.625	29	< 0.1%
0.75	7	< 0.1%
0.875	2	< 0.1%
1	5	< 0.1%
1.125	11	< 0.1%

Value	Count	Frequency (%)
313.625	1	< 0.1%
228.0952381	1	< 0.1%
226.6666667	1	< 0.1%
224.2857143	1	< 0.1%
209.7619048	1	< 0.1%
206.4285714	1	< 0.1%
205.952381	1	< 0.1%
203.0952381	1	< 0.1%
200	1	< 0.1%
197.3333333	1	< 0.1%

Noi
Real number (ℝ)

HIGH CORRELATION

Distinct	3541
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.645793

Minimum	0
Maximum	560
Zeros	769
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	11
Q1	19.5
median	27.5
Q3	43.75
95-th percentile	95
Maximum	560
Range	560
Interquartile range (IQR)	24.25

Descriptive statistics

Standard deviation	28.661477
Coefficient of variation (CV)	0.78212191
Kurtosis	12.019978
Mean	36.645793
Median Absolute Deviation (MAD)	10
Skewness	2.5391875
Sum	4386904.5
Variance	821.48029
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25	2989	2.5%
26.25	2704	2.3%
27.5	2400	2.0%
23.75	2329	1.9%
22.5	2125	1.8%
28.75	2106	1.8%
21.25	2104	1.8%
12.5	1962	1.6%
16.25	1959	1.6%
30	1909	1.6%
Other values (3531)	97124	81.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	769	0.6%
0.25	1	< 0.1%
0.375	1	< 0.1%
0.625	4	< 0.1%
0.75	2	< 0.1%
0.875	4	< 0.1%
0.9375	1	< 0.1%
1	2	< 0.1%
1.125	7	< 0.1%
1.25	7	< 0.1%

Value	Count	Frequency (%)
560	1	< 0.1%
470.25	1	< 0.1%
462.5	1	< 0.1%
441.1666667	1	< 0.1%
436.6666667	1	< 0.1%
432.5833333	1	< 0.1%
419.5833333	1	< 0.1%
380.8333333	1	< 0.1%
371.6666667	1	< 0.1%
361.25	1	< 0.1%

RSPMi
Real number (ℝ)

ZEROS

Distinct	1267
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.373495

Minimum	0
Maximum	200
Zeros	19323
Zeros (%)	16.1%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	37
median	68
Q3	98.24451
95-th percentile	161.61224
Maximum	200
Range	200
Interquartile range (IQR)	61.24451

Descriptive statistics

Standard deviation	48.414249
Coefficient of variation (CV)	0.68796141
Kurtosis	-0.31849283
Mean	70.373495
Median Absolute Deviation (MAD)	30.24451
Skewness	0.38408194
Sum	8424481.4
Variance	2343.9395
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19323	16.1%
128.7158935	3046	2.5%
98.24450975	2207	1.8%
66.58563751	1805	1.5%
129.3663472	1168	1.0%
86	989	0.8%
75	980	0.8%
84	972	0.8%
82	948	0.8%
83.61982436	946	0.8%
Other values (1257)	87327	72.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19323	16.1%
3	19	< 0.1%
4	6	< 0.1%
5	9	< 0.1%
6	8	< 0.1%
6.33	1	< 0.1%
7	15	< 0.1%
7.67	2	< 0.1%
8	5	< 0.1%
8.33	3	< 0.1%

Value	Count	Frequency (%)
200	215	0.2%
199.3332653	8	< 0.1%
199.3265307	2	< 0.1%
199.1918367	1	< 0.1%
198.9897959	1	< 0.1%
198.6530612	3	< 0.1%
198.6463265	5	< 0.1%
197.9795918	216	0.2%
197.3128571	8	< 0.1%
197.3061225	6	< 0.1%

SPMi
Real number (ℝ)

HIGH CORRELATION

Distinct	3971
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	166.98764

Minimum	0
Maximum	850.23256
Zeros	900
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	49
Q1	117.81938
median	152.66667
Q3	189.00435
95-th percentile	362.5
Maximum	850.23256
Range	850.23256
Interquartile range (IQR)	71.184973

Descriptive statistics

Standard deviation	89.826901
Coefficient of variation (CV)	0.53792545
Kurtosis	2.1109778
Mean	166.98764
Median Absolute Deviation (MAD)	34.84729
Skewness	1.3328627
Sum	19990257
Variance	8068.8722
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
117.8193762	11067	9.2%
189.0043493	9457	7.9%
145.0732291	8371	7.0%
173.3783634	7903	6.6%
161.0452865	7372	6.2%
361.7526104	3092	2.6%
67.25419257	2924	2.4%
0	900	0.8%
129.3333333	300	0.3%
150	282	0.2%
Other values (3961)	68043	56.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	900	0.8%
1	6	< 0.1%
1.61	2	< 0.1%
2	7	< 0.1%
2.99	1	< 0.1%
3	3	< 0.1%
4	7	< 0.1%
4.42	1	< 0.1%
5	2	< 0.1%
6	4	< 0.1%

Value	Count	Frequency (%)
850.2325581	1	< 0.1%
738.372093	1	< 0.1%
728.8372093	1	< 0.1%
717.4418605	1	< 0.1%
691.1627907	1	< 0.1%
684.6511628	1	< 0.1%
662.7906977	1	< 0.1%
649.5348837	1	< 0.1%
640.6976744	1	< 0.1%
637.2093023	1	< 0.1%

PMi
Real number (ℝ)

HIGH CORRELATION

Distinct	442
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48.416468

Minimum	3
Maximum	492.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	3
5-th percentile	18.855612
Q1	30.511628
median	42.204089
Q3	64.890625
95-th percentile	95.113208
Maximum	492.5
Range	489.5
Interquartile range (IQR)	34.378997

Descriptive statistics

Standard deviation	21.475136
Coefficient of variation (CV)	0.44355024
Kurtosis	2.7699212
Mean	48.416468
Median Absolute Deviation (MAD)	13.204089
Skewness	0.8678763
Sum	5795983.8
Variance	461.18146
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
64.890625	21823	18.2%
29.55044053	20143	16.8%
65.06456454	19091	15.9%
30.72969596	18878	15.8%
42.20408895	16491	13.8%
95.11320755	8180	6.8%
18.85561151	4816	4.0%
27.88636364	738	0.6%
30.51162791	591	0.5%
30	322	0.3%
Other values (432)	8638	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	1	< 0.1%
4	4	< 0.1%
5	8	< 0.1%
6	5	< 0.1%
7	9	< 0.1%
8	14	< 0.1%
9	52	< 0.1%
9.7	1	< 0.1%
9.9	1	< 0.1%
10	129	0.1%

Value	Count	Frequency (%)
492.5	1	< 0.1%
345	1	< 0.1%
281	2	< 0.1%
268	1	< 0.1%
254	1	< 0.1%
253	1	< 0.1%
250	1	< 0.1%
247	1	< 0.1%
244	1	< 0.1%
233	1	< 0.1%

AQI
Real number (ℝ)

HIGH CORRELATION

Distinct	3786
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	169.98134

Minimum	0
Maximum	850.23256
Zeros	768
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	67
Q1	117.81938
median	156.66667
Q3	189.00435
95-th percentile	362.5
Maximum	850.23256
Range	850.23256
Interquartile range (IQR)	71.184973

Descriptive statistics

Standard deviation	87.263164
Coefficient of variation (CV)	0.51336907
Kurtosis	2.3414812
Mean	169.98134
Median Absolute Deviation (MAD)	35.333333
Skewness	1.46623
Sum	20348637
Variance	7614.8597
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
117.8193762	10025	8.4%
189.0043493	9111	7.6%
145.0732291	7652	6.4%
173.3783634	7486	6.3%
161.0452865	7206	6.0%
361.7526104	3092	2.6%
67.25419257	2110	1.8%
0	768	0.6%
66.58563751	568	0.5%
128.7158935	400	0.3%
Other values (3776)	71293	59.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	768	0.6%
2.5	1	< 0.1%
6.25	1	< 0.1%
8	2	< 0.1%
10	1	< 0.1%
12	1	< 0.1%
17	3	< 0.1%
17.33	1	< 0.1%
17.5	1	< 0.1%
17.67	1	< 0.1%

Value	Count	Frequency (%)
850.2325581	1	< 0.1%
738.372093	1	< 0.1%
728.8372093	1	< 0.1%
717.4418605	1	< 0.1%
691.1627907	1	< 0.1%
684.6511628	1	< 0.1%
662.7906977	1	< 0.1%
649.5348837	1	< 0.1%
640.6976744	1	< 0.1%
637.2093023	1	< 0.1%

AQI_Range
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Poor	80608
Moderate	14902
Unhealthy	9433
Very unhealthy	7254
Hazardous	4749

Length

Max length	14
Median length	4
Mean length	5.6962351
Min length	4

Characters and Unicode

Total characters	681902
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Moderate
2nd row	Moderate
3rd row	Moderate
4th row	Moderate
5th row	Moderate

Common Values

Value	Count	Frequency (%)
Poor	80608	67.3%
Moderate	14902	12.4%
Unhealthy	9433	7.9%
Very unhealthy	7254	6.1%
Hazardous	4749	4.0%
Good	2765	2.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
poor	80608	63.5%
unhealthy	16687	13.1%
moderate	14902	11.7%
very	7254	5.7%
hazardous	4749	3.7%
good	2765	2.2%

Most occurring characters

Value	Count	Frequency (%)
o	186397	27.3%
r	107513	15.8%
P	80608	11.8%
e	53745	7.9%
a	41087	6.0%
h	33374	4.9%
t	31589	4.6%
y	23941	3.5%
d	22416	3.3%
n	16687	2.4%
Other values (10)	84545	12.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	554937	81.4%
Uppercase Letter	119711	17.6%
Space Separator	7254	1.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	186397	33.6%
r	107513	19.4%
e	53745	9.7%
a	41087	7.4%
h	33374	6.0%
t	31589	5.7%
y	23941	4.3%
d	22416	4.0%
n	16687	3.0%
l	16687	3.0%
Other values (3)	21501	3.9%

Uppercase Letter

Value	Count	Frequency (%)
P	80608	67.3%
M	14902	12.4%
U	9433	7.9%
V	7254	6.1%
H	4749	4.0%
G	2765	2.3%

Space Separator

Value	Count	Frequency (%)
	7254	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	674648	98.9%
Common	7254	1.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	186397	27.6%
r	107513	15.9%
P	80608	11.9%
e	53745	8.0%
a	41087	6.1%
h	33374	4.9%
t	31589	4.7%
y	23941	3.5%
d	22416	3.3%
n	16687	2.5%
Other values (9)	77291	11.5%

Common

Value	Count	Frequency (%)
	7254	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	681902	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	186397	27.3%
r	107513	15.8%
P	80608	11.8%
e	53745	7.9%
a	41087	6.0%
h	33374	4.9%
t	31589	4.6%
y	23941	3.5%
d	22416	3.3%
n	16687	2.4%
Other values (10)	84545	12.4%

Auto

Heatmap
Table

	so2	no2	rspm	spm	pm2_5	SOi	Noi	RSPMi	SPMi	PMi	AQI	state	type	AQI_Range
so2	1.000	0.245	0.254	0.140	-0.069	1.000	0.245	0.202	0.140	-0.069	0.154	0.036	0.028	0.026
no2	0.245	1.000	0.342	0.416	0.318	0.245	1.000	-0.067	0.416	0.318	0.423	0.191	0.046	0.157
rspm	0.254	0.342	1.000	0.669	0.403	0.254	0.342	0.217	0.669	0.403	0.708	0.159	0.048	0.298
spm	0.140	0.416	0.669	1.000	0.529	0.140	0.416	0.070	1.000	0.529	0.984	0.190	0.085	0.559
pm2_5	-0.069	0.318	0.403	0.529	1.000	-0.069	0.318	-0.044	0.529	1.000	0.524	0.346	0.050	0.155
SOi	1.000	0.245	0.254	0.140	-0.069	1.000	0.245	0.202	0.140	-0.069	0.154	0.054	0.049	0.045
Noi	0.245	1.000	0.342	0.416	0.318	0.245	1.000	-0.067	0.416	0.318	0.423	0.254	0.062	0.176
RSPMi	0.202	-0.067	0.217	0.070	-0.044	0.202	-0.067	1.000	0.070	-0.044	0.116	0.231	0.066	0.332
SPMi	0.140	0.416	0.669	1.000	0.529	0.140	0.416	0.070	1.000	0.529	0.984	0.337	0.088	0.668
PMi	-0.069	0.318	0.403	0.529	1.000	-0.069	0.318	-0.044	0.529	1.000	0.524	0.369	0.053	0.155
AQI	0.154	0.423	0.708	0.984	0.524	0.154	0.423	0.116	0.984	0.524	1.000	0.328	0.087	0.672
state	0.036	0.191	0.159	0.190	0.346	0.054	0.254	0.231	0.337	0.369	0.328	1.000	0.126	0.343
type	0.028	0.046	0.048	0.085	0.050	0.049	0.062	0.066	0.088	0.053	0.087	0.126	1.000	0.119
AQI_Range	0.026	0.157	0.298	0.559	0.155	0.045	0.176	0.332	0.668	0.155	0.672	0.343	0.119	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	state	location	type	so2	no2	rspm	spm	pm2_5	date	SOi	Noi	RSPMi	SPMi	PMi	AQI	AQI_Range
64445	Dadra & Nagar Haveli	Daman	NaN	5.2	6.1	76.53653	75.0	30.511628	6/1/1992	6.500	7.625	76.53653	75.000000	30.511628	76.536530	Moderate
64446	Dadra & Nagar Haveli	Daman	NaN	5.3	6.0	76.53653	70.0	30.511628	7/1/1992	6.625	7.500	76.53653	70.000000	30.511628	76.536530	Moderate
64447	Dadra & Nagar Haveli	Daman	NaN	6.2	7.2	76.53653	74.0	30.511628	8/1/1992	7.750	9.000	76.53653	74.000000	30.511628	76.536530	Moderate
64448	Dadra & Nagar Haveli	Daman	NaN	4.5	5.9	76.53653	75.0	30.511628	9/1/1992	5.625	7.375	76.53653	75.000000	30.511628	76.536530	Moderate
64449	Dadra & Nagar Haveli	Daman	NaN	4.8	6.4	76.53653	71.0	30.511628	10/1/1992	6.000	8.000	76.53653	71.000000	30.511628	76.536530	Moderate
64450	Dadra & Nagar Haveli	Daman	NaN	5.2	6.7	76.53653	95.0	30.511628	11/1/1992	6.500	8.375	76.53653	95.000000	30.511628	95.000000	Moderate
64451	Dadra & Nagar Haveli	Daman	NaN	4.6	6.2	76.53653	125.0	30.511628	12/1/1992	5.750	7.750	76.53653	116.666667	30.511628	116.666667	Poor
64452	Dadra & Nagar Haveli	Daman	NaN	4.9	6.7	76.53653	99.0	30.511628	1/1/1993	6.125	8.375	76.53653	99.000000	30.511628	99.000000	Moderate
64453	Dadra & Nagar Haveli	Daman	NaN	5.3	6.8	76.53653	83.0	30.511628	2/1/1993	6.625	8.500	76.53653	83.000000	30.511628	83.000000	Moderate
64454	Dadra & Nagar Haveli	Daman	NaN	5.8	6.2	76.53653	99.0	30.511628	6/1/1993	7.250	7.750	76.53653	99.000000	30.511628	99.000000	Moderate

	state	location	type	so2	no2	rspm	spm	pm2_5	date	SOi	Noi	RSPMi	SPMi	PMi	AQI	AQI_Range
435729	West Bengal	ULUBERIA	RIRUO	19.0	49.0	140.0	233.506524	64.890625	11/29/2015	23.75	61.25	179.795918	189.004349	64.890625	189.004349	Poor
435730	West Bengal	ULUBERIA	RIRUO	18.0	41.0	142.0	233.506524	64.890625	12/3/2015	22.50	51.25	183.836735	189.004349	64.890625	189.004349	Poor
435731	West Bengal	ULUBERIA	RIRUO	22.0	58.0	155.0	233.506524	64.890625	12/6/2015	27.50	72.50	0.000000	189.004349	64.890625	189.004349	Poor
435732	West Bengal	ULUBERIA	RIRUO	22.0	50.0	145.0	233.506524	64.890625	12/9/2015	27.50	62.50	189.897959	189.004349	64.890625	189.897959	Poor
435733	West Bengal	ULUBERIA	RIRUO	34.0	61.0	161.0	233.506524	64.890625	12/12/2015	42.50	76.25	0.000000	189.004349	64.890625	189.004349	Poor
435734	West Bengal	ULUBERIA	RIRUO	20.0	44.0	148.0	233.506524	64.890625	12/15/2015	25.00	55.00	195.959184	189.004349	64.890625	195.959184	Poor
435735	West Bengal	ULUBERIA	RIRUO	17.0	44.0	131.0	233.506524	64.890625	12/18/2015	21.25	55.00	161.612245	189.004349	64.890625	189.004349	Poor
435736	West Bengal	ULUBERIA	RIRUO	18.0	45.0	140.0	233.506524	64.890625	12/21/2015	22.50	56.25	179.795918	189.004349	64.890625	189.004349	Poor
435737	West Bengal	ULUBERIA	RIRUO	22.0	50.0	143.0	233.506524	64.890625	12/24/2015	27.50	62.50	185.857143	189.004349	64.890625	189.004349	Poor
435738	West Bengal	ULUBERIA	RIRUO	20.0	46.0	171.0	233.506524	64.890625	12/29/2015	25.00	57.50	0.000000	189.004349	64.890625	189.004349	Poor

Most frequently occurring

	state	location	type	so2	no2	rspm	spm	pm2_5	date	SOi	Noi	RSPMi	SPMi	PMi	AQI	AQI_Range	# duplicates
171	Tamil Nadu	Madras	Industrial Area	11.315134	21.601202	66.585638	0.0	29.550441	2/1/1994	14.143918	27.001502	66.585638	0.000000	29.550441	66.585638	Moderate	3
0	Dadra & Nagar Haveli	Daman	NaN	4.900000	6.900000	76.536530	98.0	30.511628	9/1/1994	6.125000	8.625000	76.536530	98.000000	30.511628	98.000000	Moderate	2
1	Daman & Diu	Daman Diu & Nagar	Industrial Area	2.800000	4.000000	73.749431	75.0	27.886364	9/1/1994	3.500000	5.000000	73.749431	75.000000	27.886364	75.000000	Moderate	2
2	Daman & Diu	Daman Diu & Nagar	Industrial Area	8.600000	14.200000	73.749431	118.0	27.886364	12/1/1989	10.750000	17.750000	73.749431	112.000000	27.886364	112.000000	Poor	2
3	Daman & Diu	Daman Diu & Nagar	Residential, Rural and other Areas	8.000000	10.200000	73.749431	130.0	27.886364	12/1/1989	10.000000	12.750000	73.749431	120.000000	27.886364	120.000000	Poor	2
4	Daman & Diu	Daman Diu & Nagar	Residential, Rural and other Areas	9.300000	7.100000	73.749431	134.0	27.886364	12/1/1989	11.625000	8.875000	73.749431	122.666667	27.886364	122.666667	Poor	2
5	Delhi	Delhi	Residential and others	9.300000	51.600000	246.000000	506.0	95.113208	5/4/2006	11.625000	64.500000	0.000000	417.674419	95.113208	417.674419	Hazardous	2
6	Delhi	Delhi	Residential, Rural and other Areas	12.200000	29.200000	196.639771	477.0	95.113208	9/1/1994	15.250000	36.500000	0.000000	410.930233	95.113208	410.930233	Hazardous	2
7	Delhi	Delhi	Residential, Rural and other Areas	12.300000	57.700000	196.639771	328.0	95.113208	9/1/1994	15.375000	72.125000	0.000000	278.000000	95.113208	278.000000	Unhealthy	2
8	Goa	Panjim	NaN	0.000000	0.000000	0.000000	0.0	18.855612	6/27/2003	0.000000	0.000000	0.000000	0.000000	18.855612	0.000000	Good	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Open Punctuation

Close Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring